Aubuchon Register Tools | nicholaspease.com

Nicholas Pease

My portfolio and project place.

Aubuchon Hardware Additional Register Tools

The register tools are a suite of software developed for the Aubuchon Hardware company to aid in the updating of manual UPC lookup books as well as interfacing with the backends pricing API to provide real time inventory, pricing, and product information. Due to the nature of this software, it is closed sourced.

The Suite of Tools Includes:

Generate Register Book

Generate Pallet Signs

Generate List from SKU/UPC

SKU Counter

Create-A-Sign 2

SKU Investigation

ColorX Calculator

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

Generate Register Book

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

Generate Pallet Signs

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

Generate List from SKU/UPC

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

SKU Counter

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

Create-A-Sign 2

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

SKU Investigation

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

ColorX Calculator

Generate Register Book

This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

Google Sheets Tool As an additional tool, I have developed a Google Sheets Add-On that allows the user to interface with the Aubuchon Inventory API to query information regarding inventory, product pricing and other information. It can be used to automate a wide variety of spreadsheets including inventory pick lists and many more. A redacted version of this tool is below

function AUBDATALOOKUP(input, type) {
  if (input && type) {
    var url = API_URL;
    var text = UrlFetchApp.fetch(url).getContentText();
    var json = JSON.parse(text)
    switch (type.toLowerCase()) {
      case "description":
        return json.product[0].webDesc
        break;
      case "qty":
        return json.product[0].onHandAmt
        break;
      case "price":
        return json.product[0].promoPrice != ""? "*"+json.product[0].promoPrice: json.product[0].retailPrice
        break;
      case "location":
        return json.product[0].section + " S:" + json.product[0].Slot
        break;
      case "sku":
        return json.product[0].sku
        break;
      default:
        for (var UPC in json.Table1) {
          UPC = json.Table1[UPC]
          if (UPC.Primary) return UPC.altUPC
        }
        break;
    }
  } else if (input) {
    var url = API_URL;
    var text = UrlFetchApp.fetch(url).getContentText();
    var json = JSON.parse(text)
    for (var UPC in json.Table1) {
          UPC = json.Table1[UPC]
          if (UPC.Primary) return UPC.altUPC
    }
  } else {
    return "AUBUCHON PRODUCT DATA TOOL\n[SKU TO LOOKUP], [TYPE OF DATA]\nVALID TYPES: UPC, DESCRIPTION, QTY, PRICE, LOCATION"
  }
}

© 2024 Nicholas Pease.
Last Updated on 14 Oct 2024.